Loading the SQL File 6

Connect to SQL Server

Server Name: hypv8669.hostedbyappliedi.net

User Name: ColaberryPowerBIReporting 

Password: Colaberry99

Database Name: ColaberryPowerBI_Reporting  

This is the screenshot that shows how to connect to Colaberry Server 

Loading data from SQL to power bi to create visuals 

Open power bi desktop 

Click on get data on the left side of the upper ribbon 

Choose SQL then put server name and database name 

Import the data to power bi desktop 

Then view your data 


The next step: open power bi desktop


Load your data to power bi desktop 

Server name: hypv8669.hostedbyappliedi.net

database name: ColaberryPowerBI_Reporting

To have date table query click on this button

go to model 

Create relationships between the date table and main data tio

How to create date table and main data relationship





To install power bi desktop use this link 

https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-date-tables